﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetDetalleGuiaRemisionByGuiaRemisionID')
	BEGIN
		DROP  Procedure  GetDetalleGuiaRemisionByGuiaRemisionID
	END

GO

CREATE Procedure GetDetalleGuiaRemisionByGuiaRemisionID

	(
		@idGuiaRemision int
	)


AS
begin
SELECT     IdGuiaRemision, 
           IdBien, 
           Cantidad,
           Precio
FROM       dbo.DetalleGuiaRemision
where IdGuiaRemision=@idGuiaRemision
end

GO


GRANT EXEC ON GetDetalleGuiaRemisionByGuiaRemisionID TO PUBLIC

GO


